A partition scheme is a scheme in the current database that maps the rows of a table or index into partitions based on the values of a specified column. The number and domain of the partitions of a partitioned table or index are determined in a partition scheme.
Note: Support from SQL Server 2005 or later.
Just simply click ->
Partition Scheme to
open an object pane for Partition Scheme. A control-click displays
the popup menu or using the object pane toolbar below, allowing you to create
new, edit and delete the selected partition scheme.
Create Partition Scheme
To create a new partition scheme
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New Partition Scheme from the popup menu.
- Edit partition scheme properties on the appropriate tabs of the Partition Scheme Designer.
To create a new partition scheme with modification as one of the existing partition scheme
- Select the partition scheme for modifying in the object pane.
- Control-click and select the Design
Partition Scheme from the popup menu or simply double-click the partition scheme.
or - Click the
from the object pane toolbar.
- Modify partition scheme properties on the appropriate tabs of the Partition Scheme Designer.
- Click
Save As.
To edit the existing partition scheme (manage its general etc)
- Select the partition scheme for editing in the object pane.
- Control-click and select the Design
Partition Scheme from the popup menu or simply double-click the partition scheme.
or - Click the
from the object pane toolbar.
- Edit partition scheme properties on the appropriate tabs of the Partition Scheme Designer.
To change the name of the partition scheme
- Select the partition scheme for editing in the object pane.
- Control-click and select the Rename from the popup menu.
Delete Partition Scheme
To delete a partition scheme
- Select the partition scheme for deleting in the object pane.
- Control-click and select the Delete Partition Scheme
from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Achieve Partition Scheme Information
To achieve a partition scheme information
- Select the partition scheme in the object pane.
- Choose View -> Object Information in the main menu to view the Object Information.
or - Click the
from the object pane toolbar.